/*
* Copyright (C) 2012 Manuel Pérez
*
* This file is part of OpenSudoku.
*
* OpenSudoku is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* OpenSudoku is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with OpenSudoku. If not, see <http://www.gnu.org/licenses/>.
*
*/
package dBasea;

import java.sql.ResultSet;
import java.sql.SQLException;

import dBasea.sha1.SHA1;

public class Logina {

	public boolean balidatuErabiltzailea(String Erab, String Pw)
			throws SQLException {
		Pw = SHA1.bihurtu(Pw);
		DatuBasea dbk = DatuBasea.getInstance();
		String K1 = "select * FROM Idazkariak WHERE izena='" + Erab
				+ "' AND password ='" + Pw + "'";
		ResultSet rs = dbk.executeSQL(K1);
		boolean aurki = rs.next();
		return aurki;
	}

	public boolean balioEmail(String email) throws SQLException {
		DatuBasea dbk = DatuBasea.getInstance();
		String query = "select * FROM Idazkariak WHERE email='" + email + "'";
		ResultSet rs = dbk.executeSQL(query);
		try {
			rs.next();
			return true;
		} catch (SQLException e) {
			// EMAITZA HUTSA
			e.printStackTrace();
		}
		return (Boolean) null;
	}

	public String lortuMail(String mail) throws SQLException {
		DatuBasea dbk = DatuBasea.getInstance();
		String K1 = "select password FROM Idazkariak WHERE email='" + mail
				+ "'";
		ResultSet rs = dbk.executeSQL(K1);
		try {
			rs.next();
			return rs.getString("password");
		} catch (SQLException e) {
			// EMAITZA HUTSA
			e.printStackTrace();
		}
		return null;
	}
}
